SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetTopTenGwyNews]
AS 
    SELECT TOP ( 10 )
            b.JOL_Employer_Name,
            a.JOL_EmployerName,
            a.JOL_GWY_News_ID,
            a.JOL_GWY_NewsTitle,
            a.JOL_GWY_NewsClick
    FROM    dbo.JOL_GWY_News AS a
            INNER JOIN dbo.JOL_Employer AS b ON a.JOL_EmployerName = b.JOL_Employer_Account
    ORDER BY a.JOL_GWY_AddTime DESC,
            a.JOL_GWY_UpdateTime DESC
GO
